Manage The Relationship Between Tables 9

1) Manage the relationship between Dim_JRP_Jobs and Fact_Submission_Interview_Offer table

Create the relationship between Dim_JRP_Jobs and Fact_Submissions_Interview_Offer table

- (1) Right Click to the Relationship --->Choose Properties

- (2) Change Cross Filter Direction to Both

- (3)  Click OK


2) Manage Relationship between Dim_JRP_Tags and Fact_JobReferral, Dim_JRP_Clients and Fact_JobReferral  table

Repeat step (1), (2), and (3) above to change the Cross Filter Direction between Dim_JRP_Tags and Fact_JobRefrral, Dim_JRP_Clients and Fact_JobReferral  tables to Both

 THE RELATIONSHIPS WILL LOOK LIKE THIS

 

If you went to know  more about managing the relashinshp

  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand